package com.zpphis.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

@Mapper
public interface SelectMapper {

    @Select("SELECT id,constant_name `name` FROM t_constant_item WHERE del_mark=1 AND constant_type_id=#{constantTypeId}")
    List<Map<String, Object>> constItem(int constantTypeId);

    @Select("SELECT id,dept_type_name `name` FROM t_department_type WHERE del_mark=1")
    List<Map<String, Object>> deptName();

    @Select("SELECT id,menu_title `menuTitle` FROM t_menu WHERE del_mark=1")
    List<Map<String, Object>> menuTitle();

    @Select("SELECT id,regist_name `name` FROM t_regist_level WHERE del_mark=1")
    List<Map<String, Object>> registLe();

    @Select("SELECT id,user_type_name `name` FROM t_user_type WHERE del_mark=1")
    List<Map<String, Object>> userType();
}
